会计科目

概述

科目

缺省科目

/* C_AcctSchema_Default 和 C_AcctSchema_GL 的53个默认字段 */
select b.tablename, a.columnname ,a.ismandatory,a.isactive, a.ad_reference_id  from ad_column a 
join ad_table b on a.ad_table_id=b.ad_table_id
where A.AD_Reference_ID =25  
and upper(B.tablename) ~'_GL$|DEFAULT$' 
and a.isactive='Y' 
order by 1,2

参考:Msetup.createAccountingRecord 以及437行的引用

    //  Create Defaults Accounts
    try {
      createAccountingRecord(X_C_AcctSchema_GL.Table_Name);
      createAccountingRecord(X_C_AcctSchema_Default.Table_Name);
    }
    catch (Exception e) {
      String err = e.getLocalizedMessage();
      log.log(Level.SEVERE, err);
      m_info.append(err);
      m_trx.rollback();
      m_trx.close();
      return false;
    }
/* v4.1,67个默认科目,去掉22个固定资产科目,还剩45个 */

select distinct(d.columnname), d.ismandatory as columnismandatory , a.ismandatory as fieldismandatory,   a.displaylogic from ad_field a 
join ad_tab b on a.ad_tab_id=b.ad_tab_id 
join ad_window c on b.ad_window_id=c.ad_window_id 
join ad_column d on a.ad_column_id=d.ad_column_id
where d.AD_Reference_ID=25                                       /* 列为account类型 */
and c.isactive='Y' AND b.isactive='Y' AND d.isactive='Y' and a.isactive='Y' and a.isdisplayed='Y'
and b.name !~'Records|Test|Expense|History|Line'       /* 去掉非账户设置页签 */
and d.columnname !~'^A_'                                         /* 去掉固定资产科目 */
order by 2

/* 界面45个科目有4个科目比较特殊 */
CurrencyBalancing_Acct               field显示逻辑输入
SuspenseBalancing_Acct                field显示逻辑输入
P_AverageCostVariance_Acct               field必填,column不必填 (通常field=null,column=Y)
P_LandedCostClearing_Acct               field不必填,column不必填(通常field=null,column=Y)

/* 界面45个科目与账套53个科目差异的8个科目为废弃科目 */
CB_Asset_Acct      field.isdisplayed='N'
CB_CashTransfer_Acct      field.isdisplayed='N'
CB_Differences_Acct      field.isdisplayed='N'
CB_Expense_Acct      field.isdisplayed='N'
CB_Receipt_Acct      field.isdisplayed='N'
C_Receivable_Services_Acct      field.isdisplayed='N'
V_Liability_Services_Acct      field.isdisplayed='N'
UnEarnedRevenue_Acct      field.isacitve=N  (取消都不一样)

/* 设置废弃科目为无效,请注意版本 */
update ad_column set isactive='N' 
WHERE ad_column_id in (6493,5209,5208,5207,3455,5206,14430,4872)

默认科目(54个)

固定资产科目

常见报错

新建会计科目表